Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 163 |
| Missing cells | 325 |
| Missing cells (%) | 16.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 15.4 KiB |
| Average record size in memory | 96.8 B |
Variable types
| Numeric | 12 |
|---|
ICFES_ANTIGUO is highly overall correlated with BIOLOGIA and 9 other fields | High correlation |
BIOLOGIA is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
MATEMATICA is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
FILOSOFIA is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
FISICA is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
HISTORIA is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
QUIMICA is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
LENGUAJE is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
GEOGRAFIA is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
IDIOMA is highly overall correlated with ICFES_ANTIGUO and 8 other fields | High correlation |
INTERDISCIPLINAR is highly overall correlated with ICFES_ANTIGUO | High correlation |
ICFES_ANTIGUO has 22 (13.5%) missing values | Missing |
BIOLOGIA has 19 (11.7%) missing values | Missing |
MATEMATICA has 19 (11.7%) missing values | Missing |
FILOSOFIA has 18 (11.0%) missing values | Missing |
FISICA has 18 (11.0%) missing values | Missing |
HISTORIA has 18 (11.0%) missing values | Missing |
QUIMICA has 18 (11.0%) missing values | Missing |
LENGUAJE has 19 (11.7%) missing values | Missing |
GEOGRAFIA has 18 (11.0%) missing values | Missing |
IDIOMA has 19 (11.7%) missing values | Missing |
INTERDISCIPLINAR has 137 (84.0%) missing values | Missing |
ID_ESTUDIANTE has unique values | Unique |
INTERDISCIPLINAR has 11 (6.7%) zeros | Zeros |
Reproduction
| Analysis started | 2023-09-15 01:03:12.953437 |
|---|---|
| Analysis finished | 2023-09-15 01:03:30.465504 |
| Duration | 17.51 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
ID_ESTUDIANTE
Real number (ℝ)
| Distinct | 163 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2215167.7 |
| Minimum | 2185175 |
|---|---|
| Maximum | 2237170 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 2185175 |
|---|---|
| 5-th percentile | 2185326.4 |
| Q1 | 2204975.5 |
| median | 2220180 |
| Q3 | 2230219.5 |
| 95-th percentile | 2235576.9 |
| Maximum | 2237170 |
| Range | 51995 |
| Interquartile range (IQR) | 25244 |
Descriptive statistics
| Standard deviation | 16264.874 |
|---|---|
| Coefficient of variation (CV) | 0.0073425026 |
| Kurtosis | -0.91911942 |
| Mean | 2215167.7 |
| Median Absolute Deviation (MAD) | 11198 |
| Skewness | -0.58110456 |
| Sum | 3.6107233 × 108 |
| Variance | 2.6454614 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2236077 | 1 | 0.6% |
| 2231513 | 1 | 0.6% |
| 2221978 | 1 | 0.6% |
| 2231709 | 1 | 0.6% |
| 2235011 | 1 | 0.6% |
| 2235012 | 1 | 0.6% |
| 2235053 | 1 | 0.6% |
| 2216051 | 1 | 0.6% |
| 2225180 | 1 | 0.6% |
| 2216138 | 1 | 0.6% |
| Other values (153) | 153 |
| Value | Count | Frequency (%) |
| 2185175 | 1 | |
| 2185181 | 1 | |
| 2185221 | 1 | |
| 2185265 | 1 | |
| 2185297 | 1 | |
| 2185298 | 1 | |
| 2185299 | 1 | |
| 2185300 | 1 | |
| 2185320 | 1 | |
| 2185384 | 1 |
| Value | Count | Frequency (%) |
| 2237170 | 1 | |
| 2236497 | 1 | |
| 2236496 | 1 | |
| 2236229 | 1 | |
| 2236079 | 1 | |
| 2236078 | 1 | |
| 2236077 | 1 | |
| 2235630 | 1 | |
| 2235577 | 1 | |
| 2235576 | 1 |
ICFES_ANTIGUO
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 95 |
|---|---|
| Distinct (%) | 67.4% |
| Missing | 22 |
| Missing (%) | 13.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 264.59574 |
| Minimum | 0 |
|---|---|
| Maximum | 386 |
| Zeros | 1 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 245 |
| median | 280 |
| Q3 | 315 |
| 95-th percentile | 349 |
| Maximum | 386 |
| Range | 386 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 87.537092 |
|---|---|
| Coefficient of variation (CV) | 0.33083333 |
| Kurtosis | 3.928686 |
| Mean | 264.59574 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | -1.9823079 |
| Sum | 37308 |
| Variance | 7662.7426 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 280 | 4 | 2.5% |
| 315 | 4 | 2.5% |
| 254 | 3 | 1.8% |
| 245 | 3 | 1.8% |
| 278 | 3 | 1.8% |
| 232 | 3 | 1.8% |
| 320 | 3 | 1.8% |
| 307 | 3 | 1.8% |
| 268 | 2 | 1.2% |
| Other values (85) | 103 | |
| (Missing) | 22 | 13.5% |
| Value | Count | Frequency (%) |
| 0 | 1 | 0.6% |
| 1 | 10 | |
| 188 | 1 | 0.6% |
| 196 | 1 | 0.6% |
| 205 | 1 | 0.6% |
| 207 | 2 | 1.2% |
| 211 | 1 | 0.6% |
| 218 | 1 | 0.6% |
| 220 | 1 | 0.6% |
| 225 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 386 | 1 | |
| 383 | 1 | |
| 381 | 1 | |
| 378 | 1 | |
| 368 | 1 | |
| 363 | 1 | |
| 356 | 1 | |
| 349 | 2 | |
| 345 | 1 | |
| 344 | 1 |
BIOLOGIA
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 43 |
|---|---|
| Distinct (%) | 29.9% |
| Missing | 19 |
| Missing (%) | 11.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.673819 |
| Minimum | 1 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 47 |
| median | 54 |
| Q3 | 62 |
| 95-th percentile | 71 |
| Maximum | 76 |
| Range | 75 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 16.81104 |
|---|---|
| Coefficient of variation (CV) | 0.32532992 |
| Kurtosis | 3.3278208 |
| Mean | 51.673819 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -1.7260438 |
| Sum | 7441.03 |
| Variance | 282.61105 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 58 | 8 | 4.9% |
| 53 | 7 | 4.3% |
| 51 | 7 | 4.3% |
| 56 | 6 | 3.7% |
| 52 | 6 | 3.7% |
| 60 | 6 | 3.7% |
| 66 | 6 | 3.7% |
| 45 | 5 | 3.1% |
| 55 | 5 | 3.1% |
| Other values (33) | 78 | |
| (Missing) | 19 | 11.7% |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 31 | 1 | 0.6% |
| 34 | 1 | 0.6% |
| 36 | 2 | 1.2% |
| 37 | 1 | 0.6% |
| 38 | 1 | 0.6% |
| 39 | 3 | 1.8% |
| 40 | 2 | 1.2% |
| 41 | 1 | 0.6% |
| 42 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 76 | 2 | 1.2% |
| 75 | 1 | 0.6% |
| 72 | 3 | |
| 71 | 3 | |
| 70 | 3 | |
| 69 | 3 | |
| 68 | 3 | |
| 67 | 2 | 1.2% |
| 66 | 6 | |
| 65 | 3 |
MATEMATICA
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 42 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 19 |
| Missing (%) | 11.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.216111 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 50 |
| median | 58 |
| Q3 | 63 |
| 95-th percentile | 73.85 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 17.38165 |
|---|---|
| Coefficient of variation (CV) | 0.32059934 |
| Kurtosis | 3.9817054 |
| Mean | 54.216111 |
| Median Absolute Deviation (MAD) | 6.5 |
| Skewness | -1.7393765 |
| Sum | 7807.12 |
| Variance | 302.12174 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=42)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 61 | 10 | 6.1% |
| 60 | 8 | 4.9% |
| 53 | 8 | 4.9% |
| 58 | 8 | 4.9% |
| 63 | 7 | 4.3% |
| 54 | 6 | 3.7% |
| 50 | 6 | 3.7% |
| 66 | 6 | 3.7% |
| 51 | 5 | 3.1% |
| Other values (32) | 70 | |
| (Missing) | 19 | 11.7% |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 33 | 1 | 0.6% |
| 35 | 1 | 0.6% |
| 39 | 1 | 0.6% |
| 40 | 1 | 0.6% |
| 41 | 2 | 1.2% |
| 42.12 | 1 | 0.6% |
| 43 | 1 | 0.6% |
| 44 | 3 | 1.8% |
| 45 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 100 | 1 | 0.6% |
| 82 | 1 | 0.6% |
| 79 | 1 | 0.6% |
| 76 | 1 | 0.6% |
| 75 | 1 | 0.6% |
| 74 | 3 | |
| 73 | 1 | 0.6% |
| 72 | 4 | |
| 70 | 2 | |
| 69 | 3 |
FILOSOFIA
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 46 |
|---|---|
| Distinct (%) | 31.7% |
| Missing | 18 |
| Missing (%) | 11.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.452207 |
| Minimum | 1 |
|---|---|
| Maximum | 83 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 51 |
| median | 58 |
| Q3 | 64 |
| 95-th percentile | 72.8 |
| Maximum | 83 |
| Range | 82 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 17.4714 |
|---|---|
| Coefficient of variation (CV) | 0.32085752 |
| Kurtosis | 3.6596279 |
| Mean | 54.452207 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -1.8265131 |
| Sum | 7895.57 |
| Variance | 305.24982 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=46)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 63 | 9 | 5.5% |
| 58 | 8 | 4.9% |
| 57 | 7 | 4.3% |
| 54 | 7 | 4.3% |
| 55 | 6 | 3.7% |
| 62 | 5 | 3.1% |
| 70 | 5 | 3.1% |
| 66 | 5 | 3.1% |
| 59 | 5 | 3.1% |
| Other values (36) | 78 | |
| (Missing) | 18 | 11.0% |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 31 | 1 | 0.6% |
| 36 | 1 | 0.6% |
| 37 | 1 | 0.6% |
| 38 | 1 | 0.6% |
| 39 | 1 | 0.6% |
| 40 | 2 | 1.2% |
| 41 | 4 | 2.5% |
| 42 | 1 | 0.6% |
| 44 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 83 | 1 | 0.6% |
| 81 | 1 | 0.6% |
| 80 | 1 | 0.6% |
| 79 | 1 | 0.6% |
| 78 | 1 | 0.6% |
| 75 | 2 | 1.2% |
| 73 | 1 | 0.6% |
| 72 | 3 | |
| 71 | 2 | 1.2% |
| 70 | 5 |
FISICA
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 40 |
|---|---|
| Distinct (%) | 27.6% |
| Missing | 18 |
| Missing (%) | 11.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53.815172 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 50 |
| median | 57 |
| Q3 | 63 |
| 95-th percentile | 72 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 17.343364 |
|---|---|
| Coefficient of variation (CV) | 0.32227647 |
| Kurtosis | 3.8155992 |
| Mean | 53.815172 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -1.7345002 |
| Sum | 7803.2 |
| Variance | 300.79227 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=40)
| Value | Count | Frequency (%) |
| 60 | 10 | 6.1% |
| 1 | 10 | 6.1% |
| 53 | 9 | 5.5% |
| 58 | 8 | 4.9% |
| 61 | 7 | 4.3% |
| 50 | 7 | 4.3% |
| 47 | 6 | 3.7% |
| 63 | 6 | 3.7% |
| 59 | 6 | 3.7% |
| 55 | 5 | 3.1% |
| Other values (30) | 71 | |
| (Missing) | 18 | 11.0% |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 30 | 1 | 0.6% |
| 32 | 1 | 0.6% |
| 35 | 1 | 0.6% |
| 36 | 2 | 1.2% |
| 37 | 1 | 0.6% |
| 41 | 3 | 1.8% |
| 44 | 2 | 1.2% |
| 45 | 1 | 0.6% |
| 47 | 6 |
| Value | Count | Frequency (%) |
| 100 | 1 | 0.6% |
| 79 | 1 | 0.6% |
| 76 | 1 | 0.6% |
| 74 | 2 | 1.2% |
| 72 | 5 | |
| 71 | 3 | |
| 70 | 2 | 1.2% |
| 69 | 3 | |
| 68 | 3 | |
| 67 | 3 |
HISTORIA
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 48 |
|---|---|
| Distinct (%) | 33.1% |
| Missing | 18 |
| Missing (%) | 11.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.582552 |
| Minimum | 1 |
|---|---|
| Maximum | 81 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 44 |
| median | 56 |
| Q3 | 63 |
| 95-th percentile | 72.8 |
| Maximum | 81 |
| Range | 80 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 17.682837 |
|---|---|
| Coefficient of variation (CV) | 0.34280656 |
| Kurtosis | 2.2459668 |
| Mean | 51.582552 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | -1.4334964 |
| Sum | 7479.47 |
| Variance | 312.68273 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=48)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 66 | 7 | 4.3% |
| 44 | 7 | 4.3% |
| 59 | 7 | 4.3% |
| 58 | 6 | 3.7% |
| 63 | 6 | 3.7% |
| 57 | 6 | 3.7% |
| 67 | 5 | 3.1% |
| 42 | 5 | 3.1% |
| 43 | 5 | 3.1% |
| Other values (38) | 81 | |
| (Missing) | 18 | 11.0% |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 30 | 2 | 1.2% |
| 31 | 1 | 0.6% |
| 32 | 1 | 0.6% |
| 33 | 1 | 0.6% |
| 35 | 1 | 0.6% |
| 36 | 1 | 0.6% |
| 37 | 1 | 0.6% |
| 38 | 3 | 1.8% |
| 40 | 2 | 1.2% |
| Value | Count | Frequency (%) |
| 81 | 1 | 0.6% |
| 77 | 1 | 0.6% |
| 76 | 2 | |
| 74 | 2 | |
| 73 | 2 | |
| 72 | 1 | 0.6% |
| 71 | 2 | |
| 70 | 2 | |
| 69 | 4 | |
| 68 | 2 |
QUIMICA
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 45 |
|---|---|
| Distinct (%) | 31.0% |
| Missing | 18 |
| Missing (%) | 11.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.672483 |
| Minimum | 1 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 47 |
| median | 55 |
| Q3 | 62 |
| 95-th percentile | 71 |
| Maximum | 76 |
| Range | 75 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 16.838986 |
|---|---|
| Coefficient of variation (CV) | 0.32587916 |
| Kurtosis | 3.243516 |
| Mean | 51.672483 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -1.7171194 |
| Sum | 7492.51 |
| Variance | 283.55143 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=45)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 58 | 8 | 4.9% |
| 56 | 7 | 4.3% |
| 53 | 7 | 4.3% |
| 60 | 7 | 4.3% |
| 51 | 6 | 3.7% |
| 55 | 6 | 3.7% |
| 66 | 6 | 3.7% |
| 52 | 6 | 3.7% |
| 54 | 5 | 3.1% |
| Other values (35) | 77 | |
| (Missing) | 18 | 11.0% |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 31 | 1 | 0.6% |
| 33 | 1 | 0.6% |
| 34 | 1 | 0.6% |
| 36 | 1 | 0.6% |
| 37 | 1 | 0.6% |
| 37.51 | 1 | 0.6% |
| 38 | 1 | 0.6% |
| 39 | 3 | 1.8% |
| 40 | 2 | 1.2% |
| Value | Count | Frequency (%) |
| 76 | 1 | 0.6% |
| 75 | 1 | 0.6% |
| 74 | 1 | 0.6% |
| 72 | 3 | |
| 71 | 4 | |
| 70 | 2 | 1.2% |
| 69 | 3 | |
| 68 | 3 | |
| 67 | 2 | 1.2% |
| 66 | 6 |
LENGUAJE
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 44 |
|---|---|
| Distinct (%) | 30.6% |
| Missing | 19 |
| Missing (%) | 11.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.926319 |
| Minimum | 1 |
|---|---|
| Maximum | 83 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 51 |
| median | 58 |
| Q3 | 65 |
| 95-th percentile | 74.7 |
| Maximum | 83 |
| Range | 82 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 17.501654 |
|---|---|
| Coefficient of variation (CV) | 0.31863876 |
| Kurtosis | 3.8664893 |
| Mean | 54.926319 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -1.8796582 |
| Sum | 7909.39 |
| Variance | 306.3079 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=44)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 63 | 9 | 5.5% |
| 58 | 7 | 4.3% |
| 57 | 7 | 4.3% |
| 54 | 6 | 3.7% |
| 70 | 6 | 3.7% |
| 59 | 5 | 3.1% |
| 66 | 5 | 3.1% |
| 60 | 5 | 3.1% |
| 55 | 5 | 3.1% |
| Other values (34) | 79 | |
| (Missing) | 19 | 11.7% |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 31 | 1 | 0.6% |
| 37 | 1 | 0.6% |
| 39 | 1 | 0.6% |
| 40 | 2 | 1.2% |
| 41 | 2 | 1.2% |
| 42 | 1 | 0.6% |
| 43 | 1 | 0.6% |
| 44 | 2 | 1.2% |
| 45 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 83 | 1 | |
| 81 | 1 | |
| 80 | 1 | |
| 79 | 1 | |
| 78 | 1 | |
| 76 | 1 | |
| 75 | 2 | |
| 73 | 1 | |
| 72 | 2 | |
| 71 | 2 |
GEOGRAFIA
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 49 |
|---|---|
| Distinct (%) | 33.8% |
| Missing | 18 |
| Missing (%) | 11.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.612414 |
| Minimum | 1 |
|---|---|
| Maximum | 81 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 44 |
| median | 56 |
| Q3 | 63 |
| 95-th percentile | 71.8 |
| Maximum | 81 |
| Range | 80 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 17.682041 |
|---|---|
| Coefficient of variation (CV) | 0.34259279 |
| Kurtosis | 2.2438414 |
| Mean | 51.612414 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | -1.456458 |
| Sum | 7483.8 |
| Variance | 312.65457 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=49)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 59 | 7 | 4.3% |
| 66 | 7 | 4.3% |
| 63 | 6 | 3.7% |
| 55 | 6 | 3.7% |
| 57 | 6 | 3.7% |
| 44 | 6 | 3.7% |
| 58 | 5 | 3.1% |
| 52 | 5 | 3.1% |
| 67 | 5 | 3.1% |
| Other values (39) | 82 | |
| (Missing) | 18 | 11.0% |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 30 | 2 | 1.2% |
| 31 | 1 | 0.6% |
| 32 | 1 | 0.6% |
| 33 | 1 | 0.6% |
| 35 | 1 | 0.6% |
| 36 | 1 | 0.6% |
| 36.8 | 1 | 0.6% |
| 37 | 2 | 1.2% |
| 38 | 3 | 1.8% |
| Value | Count | Frequency (%) |
| 81 | 1 | 0.6% |
| 77 | 1 | 0.6% |
| 76 | 1 | 0.6% |
| 74 | 2 | |
| 73 | 2 | |
| 72 | 1 | 0.6% |
| 71 | 3 | |
| 70 | 1 | 0.6% |
| 69 | 4 | |
| 68 | 2 |
IDIOMA
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 45 |
|---|---|
| Distinct (%) | 31.2% |
| Missing | 19 |
| Missing (%) | 11.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.283264 |
| Minimum | 0 |
|---|---|
| Maximum | 84 |
| Zeros | 1 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 49 |
| median | 57 |
| Q3 | 68.25 |
| 95-th percentile | 78 |
| Maximum | 84 |
| Range | 84 |
| Interquartile range (IQR) | 19.25 |
Descriptive statistics
| Standard deviation | 18.934888 |
|---|---|
| Coefficient of variation (CV) | 0.3425067 |
| Kurtosis | 2.7750392 |
| Mean | 55.283264 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -1.5971287 |
| Sum | 7960.79 |
| Variance | 358.53 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=45)
| Value | Count | Frequency (%) |
| 1 | 10 | 6.1% |
| 55 | 9 | 5.5% |
| 70 | 7 | 4.3% |
| 58 | 6 | 3.7% |
| 57 | 6 | 3.7% |
| 47 | 6 | 3.7% |
| 71 | 6 | 3.7% |
| 61 | 6 | 3.7% |
| 52 | 5 | 3.1% |
| 72 | 5 | 3.1% |
| Other values (35) | 78 | |
| (Missing) | 19 | 11.7% |
| Value | Count | Frequency (%) |
| 0 | 1 | 0.6% |
| 1 | 10 | |
| 31 | 1 | 0.6% |
| 37 | 1 | 0.6% |
| 39.79 | 1 | 0.6% |
| 41 | 1 | 0.6% |
| 42 | 3 | 1.8% |
| 43 | 1 | 0.6% |
| 44 | 2 | 1.2% |
| 46 | 4 | 2.5% |
| Value | Count | Frequency (%) |
| 84 | 1 | 0.6% |
| 83 | 1 | 0.6% |
| 82 | 1 | 0.6% |
| 80 | 2 | 1.2% |
| 79 | 2 | 1.2% |
| 78 | 2 | 1.2% |
| 75 | 1 | 0.6% |
| 74 | 4 | |
| 73 | 3 | |
| 72 | 5 |
INTERDISCIPLINAR
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 7 |
|---|---|
| Distinct (%) | 26.9% |
| Missing | 137 |
| Missing (%) | 84.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.024231 |
| Minimum | 0 |
|---|---|
| Maximum | 353 |
| Zeros | 11 |
| Zeros (%) | 6.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 61.25 |
| Maximum | 353 |
| Range | 353 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 69.986313 |
|---|---|
| Coefficient of variation (CV) | 3.4950812 |
| Kurtosis | 22.686409 |
| Mean | 20.024231 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.6627337 |
| Sum | 520.63 |
| Variance | 4898.0841 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 0 | 11 | 6.7% |
| 1 | 10 | 6.1% |
| 4 | 1 | 0.6% |
| 44 | 1 | 0.6% |
| 67 | 1 | 0.6% |
| 353 | 1 | 0.6% |
| 42.63 | 1 | 0.6% |
| (Missing) | 137 |
| Value | Count | Frequency (%) |
| 0 | 11 | |
| 1 | 10 | |
| 4 | 1 | 0.6% |
| 42.63 | 1 | 0.6% |
| 44 | 1 | 0.6% |
| 67 | 1 | 0.6% |
| 353 | 1 | 0.6% |
| Value | Count | Frequency (%) |
| 353 | 1 | 0.6% |
| 67 | 1 | 0.6% |
| 44 | 1 | 0.6% |
| 42.63 | 1 | 0.6% |
| 4 | 1 | 0.6% |
| 1 | 10 | |
| 0 | 11 |
| ID_ESTUDIANTE | ICFES_ANTIGUO | BIOLOGIA | MATEMATICA | FILOSOFIA | FISICA | HISTORIA | QUIMICA | LENGUAJE | GEOGRAFIA | IDIOMA | INTERDISCIPLINAR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID_ESTUDIANTE | 1.000 | -0.147 | -0.288 | -0.198 | -0.222 | -0.228 | -0.224 | -0.279 | -0.173 | -0.210 | -0.138 | 0.127 |
| ICFES_ANTIGUO | -0.147 | 1.000 | 0.911 | 0.880 | 0.919 | 0.865 | 0.945 | 0.909 | 0.899 | 0.932 | 0.784 | -0.514 |
| BIOLOGIA | -0.288 | 0.911 | 1.000 | 0.754 | 0.775 | 0.799 | 0.804 | 0.992 | 0.734 | 0.796 | 0.665 | -0.085 |
| MATEMATICA | -0.198 | 0.880 | 0.754 | 1.000 | 0.730 | 0.900 | 0.762 | 0.755 | 0.709 | 0.757 | 0.716 | -0.258 |
| FILOSOFIA | -0.222 | 0.919 | 0.775 | 0.730 | 1.000 | 0.750 | 0.827 | 0.768 | 0.962 | 0.820 | 0.623 | -0.120 |
| FISICA | -0.228 | 0.865 | 0.799 | 0.900 | 0.750 | 1.000 | 0.747 | 0.794 | 0.724 | 0.723 | 0.683 | -0.170 |
| HISTORIA | -0.224 | 0.945 | 0.804 | 0.762 | 0.827 | 0.747 | 1.000 | 0.799 | 0.794 | 0.984 | 0.639 | -0.129 |
| QUIMICA | -0.279 | 0.909 | 0.992 | 0.755 | 0.768 | 0.794 | 0.799 | 1.000 | 0.728 | 0.804 | 0.660 | -0.123 |
| LENGUAJE | -0.173 | 0.899 | 0.734 | 0.709 | 0.962 | 0.724 | 0.794 | 0.728 | 1.000 | 0.790 | 0.623 | -0.117 |
| GEOGRAFIA | -0.210 | 0.932 | 0.796 | 0.757 | 0.820 | 0.723 | 0.984 | 0.804 | 0.790 | 1.000 | 0.627 | -0.167 |
| IDIOMA | -0.138 | 0.784 | 0.665 | 0.716 | 0.623 | 0.683 | 0.639 | 0.660 | 0.623 | 0.627 | 1.000 | -0.454 |
| INTERDISCIPLINAR | 0.127 | -0.514 | -0.085 | -0.258 | -0.120 | -0.170 | -0.129 | -0.123 | -0.117 | -0.167 | -0.454 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| ID_ESTUDIANTE | ICFES_ANTIGUO | BIOLOGIA | MATEMATICA | FILOSOFIA | FISICA | HISTORIA | QUIMICA | LENGUAJE | GEOGRAFIA | IDIOMA | INTERDISCIPLINAR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2236077 | 280.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 2236078 | 349.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 2236079 | 340.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 2220846 | 344.0 | 69.0 | 72.0 | 66.0 | 72.0 | 66.0 | 69.0 | 67.0 | 66.0 | 73.0 | NaN |
| 4 | 2220847 | 304.0 | 66.0 | 61.0 | 58.0 | 61.0 | 58.0 | 66.0 | 58.0 | 58.0 | 62.0 | NaN |
| 5 | 2220848 | 284.0 | 54.0 | 56.0 | 62.0 | 56.0 | 56.0 | 54.0 | 62.0 | 56.0 | 55.0 | NaN |
| 6 | 2185320 | NaN | 50.0 | 58.0 | 54.0 | 50.0 | 63.0 | 50.0 | 54.0 | 63.0 | 61.0 | NaN |
| 7 | 2185384 | NaN | 72.0 | 82.0 | 50.0 | 72.0 | 69.0 | 72.0 | 50.0 | 69.0 | 80.0 | NaN |
| 8 | 2185526 | NaN | 62.0 | 66.0 | 62.0 | 62.0 | 59.0 | 62.0 | 69.0 | 59.0 | 42.0 | 4.0 |
| 9 | 2185527 | NaN | 55.0 | 39.0 | 55.0 | 55.0 | 55.0 | 55.0 | 51.0 | 55.0 | 44.0 | 44.0 |
| ID_ESTUDIANTE | ICFES_ANTIGUO | BIOLOGIA | MATEMATICA | FILOSOFIA | FISICA | HISTORIA | QUIMICA | LENGUAJE | GEOGRAFIA | IDIOMA | INTERDISCIPLINAR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153 | 2185300 | NaN | 58.0 | 58.0 | 64.0 | 58.0 | 59.0 | 58.0 | 64.0 | 59.0 | 72.0 | NaN |
| 154 | 2185512 | 288.0 | 62.0 | 61.0 | 57.0 | 62.0 | 57.0 | 62.0 | 53.0 | 57.0 | 48.0 | NaN |
| 155 | 2185265 | NaN | 53.0 | 62.0 | 52.0 | 53.0 | 60.0 | 53.0 | 52.0 | 60.0 | 56.0 | NaN |
| 156 | 2186045 | NaN | 66.0 | 69.0 | 72.0 | 66.0 | 61.0 | 66.0 | 72.0 | 61.0 | 70.0 | NaN |
| 157 | 2185619 | NaN | 71.0 | 73.0 | 63.0 | 71.0 | 63.0 | 71.0 | 63.0 | 63.0 | 70.0 | NaN |
| 158 | 2186315 | NaN | 45.0 | 50.0 | 60.0 | 45.0 | 54.0 | 45.0 | 60.0 | 54.0 | 48.0 | NaN |
| 159 | 2185175 | NaN | 58.0 | 61.0 | 66.0 | 58.0 | 67.0 | 58.0 | 66.0 | 67.0 | 47.0 | NaN |
| 160 | 2186323 | NaN | 47.0 | 57.0 | 58.0 | 47.0 | 55.0 | 47.0 | 58.0 | 55.0 | 49.0 | NaN |
| 161 | 2186063 | NaN | 65.0 | 58.0 | 58.0 | 65.0 | 40.0 | 65.0 | 58.0 | 40.0 | 60.0 | NaN |
| 162 | 2185181 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |